﻿CREATE TABLE [dbo].[t_request]
(
    [id] UNIQUEIDENTIFIER NOT NULL, 
    [date] DATE NOT NULL,
    [guid] UNIQUEIDENTIFIER NOT NULL,
    [type] TINYINT NOT NULL,
    [created] DATETIMEOFFSET NOT NULL, 
    [created_by] NVARCHAR(64) NOT NULL, 
    [modified] DATETIMEOFFSET NOT NULL, 
    [modified_by] NVARCHAR(64) NOT NULL, 
    [row_version] TIMESTAMP NOT NULL, 
    CONSTRAINT [pk_t_request] PRIMARY KEY NONCLUSTERED ([id])
)

GO

CREATE CLUSTERED INDEX [ix_t_request_key] ON [dbo].[t_request] ([date], [guid], [type])

GO

CREATE NONCLUSTERED INDEX [ix_t_request_created] ON [dbo].[t_request] ([created])
